Dynamic calculations enhance the consolidation performance because the amount is calculated when requested for display and is not written to the database.
Use dynamic calculations in cube views and business rules.
-
There is no performance impact on consolidation times.
-
You can make dynamic calculations drillable so users can see the source for the calculated result when drilling down.
-
Use these calculations for ratios or variances.
In the dimension library, write dynamic calculations on specific members. They will calculate at runtime.
Dynamic calculations have a syntax similar to GetDataCell expressions because they also require reference to specific dimension members to return a data point.
NOTE: A difference between dynamic calculations and GetDataCell expressions is that dynamic calculations require proper business rule logic.
Use dynamic calculations if you need a repository of commonly used calculations which allows for consistency and reduces maintenance.
Create common calculations in the UD8 dimension. It allows you to have the most flexibility with your rule syntax.
Use another calculation type if the calculation is only used on a specific cube view because you may not want to create a member in the dimension library. Also, consider if you will grant a report builder access to the dimension library to view, create, and edit these calculations.
